package com.example.mytayunapi.Service;
import com.example.mytayunapi.Vo.RefundProductsOrders;
import com.github.pagehelper.PageInfo;//分页
import com.example.mytayunapi.Entity.productsInfo;
import com.example.mytayunapi.Vo.UserProductImage;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface productsInfoService {
    Integer deleteRefund(@Param("Refund_id") String Refund_id);

    List<RefundProductsOrders> findRefundProductsOrdersBySchoolDegree(@Param("School_degree") String School_degree);

    List<productsInfo> findByCategoryAndstatus(String category);

    List<productsInfo> findByCategory(String category);

    List<productsInfo> getDownProducts();

    Integer updateProductStatus(productsInfo productsinfo);
//
    //(郭)
    List<productsInfo> getInfoByReleaseStatus();

    List<UserProductImage> getImageUserProduct();
    List<productsInfo> getProductsInfoByReleaseStatus(String Release_status);
    Integer insertProductsInfo(productsInfo productsinfo);

    List<UserProductImage> getImageUserProductId(Integer Product_id);

    Integer updateProductsInfoByProductId(UserProductImage productsStatusInfo);

    PageInfo<UserProductImage>  getPageInfo(int pageNum, int pageSize);//上架商品审核分页

    PageInfo<productsInfo>  getPageInfos(int pageNum, int pageSize);//在售商品分页

    PageInfo<productsInfo>  getPageInfoU(int pageNum, int pageSize);//下架商品分页

    List<UserProductImage> getImageUserProductByReleaseStatus(String Release_status);//查询未审核商品

    List<UserProductImage> getImageUserProductByReleaseStatusNot(String Release_status);//查询除了审核中之外的商品

    List<UserProductImage> getImageUserProductByReleaseStatusAndId(String Release_status,Integer Product_id);//用商品编号和商品审核状态做联合查询

    List<UserProductImage> getImageUserProductByReleaseStatusAndIdProAcate(String category, String subcategory, String keyword);

    List<UserProductImage> getImageUserProductByRelease();

    List<UserProductImage> getImageUserProductByCategory(String category);

    List<UserProductImage> getImageUserProductBySubcategory(String subcategory);

    List<UserProductImage> getImageUserProductByKeyword(String keyword);

    Integer insertProducts(productsInfo productsinfo);

    List<UserProductImage> getmaijiaProductByProductId(Integer Product_id);

    productsInfo saveProduct(productsInfo product);

    List<productsInfo> getProductByKeyword(String keyword);

    List<Map<String, Object>> getEchartCake();




//    List<UserProductImage> getProductsInfoByProductName(String Product_name);

//    List<UserProductImage> getProductsInfoByProductName(String Product_name, Timestamp Product_time);
}
